﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using School.Entities;
//using System.Data.Entity;
using School.Entities;

namespace School.Common
{
    public static class LookUps
    {
        private static SchoolEntities db = new SchoolEntities();

        public static IEnumerable<LU_Stat> State()
        {
            return from x in db.LU_Stat orderby x.Name select x;
        }


        public static IEnumerable<LU_District> GetDestrictByState(int stateid)
        {



            return from x in db.LU_District where x.Stat_Id == stateid orderby x.Name select x;
        }


        public static IEnumerable<LU_Jobs> Jobs()
        {
            return from x in db.LU_Jobs orderby x.Name select x;
        }

        public static IEnumerable<LU_Country> Countries()
        {
            return from x in db.LU_Country orderby x.Name select x;
        }

        public static IEnumerable<LU_District> Districts()
        {
            return from x in db.LU_District orderby x.Name select x;
        }

        public static IEnumerable<LU_Language> Languages()
        {
            return from x in db.LU_Language orderby x.Name select x;
        }

        public static IEnumerable<LU_Religion> Religions()
        {
            return from x in db.LU_Religion orderby x.Name select x;
        }

        public static IEnumerable<LU_WeekDay> WeekDays()
        {
            return from x in db.LU_WeekDay orderby x.Name select x;
        }

        public static IEnumerable<LU_Gender> Genders()
        {
            return from x in db.LU_Gender orderby x.Kind select x;
        }

        public static IEnumerable<LU_Qualification> Qualifications()
        {
            return from x in db.LU_Qualification orderby x.Name select x;
        }

        public static IEnumerable<SD_ParentsSocialStatus> ParentsSocialStatus()
        {
            return from x in db.SD_ParentsSocialStatus orderby x.Name select x;
        }

        public static IEnumerable<SD_CustodyType> CustodyType()
        {
            return from x in db.SD_CustodyType orderby x.Name select x;
        }

        public static IEnumerable<SD_LivingWith> LivingWith()
        {
            return from x in db.SD_LivingWith orderby x.Name select x;
        }


        public static IEnumerable<SD_QualificationSkill> QualificationSkill()
        {
            return from x in db.SD_QualificationSkill orderby x.Capability select x;
        }

        public static IEnumerable<ADM_Status_Type> StatusType()
        {
            return from x in db.ADM_Status_Type orderby x.Name select x;
        }



    }
}
